← Rupert Thieme Freelance Marketing
Work Experience Services Get a quote
garden

Case Study · Organic TikTok content strategy

Finding the TikTok topics
a garden brand can own —
without making ads.

Agency Phoenix Agency — York University co-op placement, not a direct employee
Client brand Environmental Factor — Canadian biotech, neonic-free pest control
Brief A co-op assignment — "come up with TikTok content ideas"
Scope Topic research · multi-tool demand audit · 12-step method
Tools Google Trends · TikTok Creative Center · Answerthepublic · Claude · PowerShell · manual TikTok audit
Source log 40-page working log, embedded throughout
Approach Original brief 2023 · rebuilt Apr–May 2026 as the method I would run today
01

The brief

In 2023 I was on a York University co-op placement at Phoenix Agency. It is worth being precise about that arrangement: a co-op placement is a temporary, university-run work term, so I was a placed student rather than a direct employee of the agency. During that placement, the manager I reported to asked me to come up with content ideas for a TikTok strategy for Environmental Factor — one of the agency's clients, a Canadian biotech brand that makes solutions for protecting a garden or a piece of agricultural land in an environmentally friendly way. The task as handed to me was narrow. I was asked to produce ideas, not content briefs, and certainly not finished posts. What I actually did with it was wider than that, because I thought the only way to produce ideas worth keeping was to build the small strategy that the ideas were supposed to sit inside.

I want to be upfront about something before any of the rest of this. I no longer have the original notes from that co-op assignment, so this is deliberately not a transcript of exactly what I did in 2023. It is a present-day reconstruction — the method as I would approach and solve the same brief today, with the tools and the judgement I would now bring to it. The 2023 placement is the origin of the brief and nothing more; every method step, screenshot and dataset below comes from a fresh re-run I carried out in 2026. I think that is worth stating plainly at the top rather than letting a reader assume otherwise.

The reason I treated a content-ideas task as a strategy task is that TikTok punishes you for skipping the strategy. It is an awareness-heavy platform. People do not show up for over-polished work, and they show up for ad content even less than they do on Instagram. I would say TikTok is really a top-of-funnel platform — organic videos and genuinely helpful content draw people in, and only then do they enter the funnel at all. Content has to feel authentic, and it has to feel like it is starting a real conversation rather than closing a sale.

On the reconstruction: the original 2023 work was a co-op assignment — a set of content ideas delivered to the manager I reported to during my placement at Phoenix Agency, not work I did as a direct agency employee. Those notes are long gone. So everything documented here — the cluster choices, the tool stack, the spider-web dataset, the audit explorer — is the method as I would run it today, captured fresh in a 40-page working log over April and May 2026. I have kept that honesty edge in rather than presenting a tidied-up history, because the method is the part worth showing, and the method does not depend on the original notes surviving.
3
Content clusters validated end-to-end — pest control, soil amendments, lawn care
418
TikTok post observations audited by hand across 129 unique queries
$0
Spend — entire audit run on free tiers, Claude and a PowerShell script

Why awareness content earns its place

The argument for top-of-funnel content here is mostly an economic one. If you draw people in with entertainment or education, then once they follow you, you no longer carry the recurring cost of a paid campaign to reach them again — and you have already had a clear opportunity to differentiate the brand before anyone is being sold anything. It also reaches the right people. Awareness content works mostly on the 90%-plus who are still working out which solution they need, or whether they need one at all, and to a lesser extent on people shopping around and comparing. It works much less on people who are already searching to buy, which is the most competitive and most expensive space to fight in.

So before touching a single tool, I had a working hypothesis: the content should start with what customers can do with and around the products, rather than with the products themselves. For a brand that sells garden and soil protection, that pointed fairly clearly at gardening and soil-care content as the place to begin.

Log · page 1The hypothesis I started from
Why TikTok is a top-of-funnel platform — and the first look at what the brand sells
Open page 1 →
First page of the log — the platform logic, and the brief I set myself before opening any research tool

The method, in twelve steps

The rest of this case study walks the method in order. I have laid it out as a pipeline up front so the whole shape is visible before the detail arrives. Each step below becomes its own chapter, in the same order, and the screenshots from the working log are embedded at the exact point each one informed a decision.

Environmental Factor · TikTok topic-research method
Step 1Read the brandSite, about page, the actual USP — researched, not assumed.
Step 2Pick the funnelB2C before B2B, awareness before conversion.
Step 3Map the productsCatalogue what each product does, not what it is.
Step 4Set the clustersThree clusters, one spreadsheet schema, fixed up front.
Step 5Google TrendsValidate each cluster has real demand behind it.
Step 6Creative CenterTikTok's own tools for hashtags and trends.
Step 7Spider webAnswerthepublic, expanded manually then with Claude.
Step 8Rank itPowerShell top-10 by traffic, cleaned of noise.
Step 9Manual auditTop 10 TikTok posts per query, captured by hand.
Step 10Audit ExplorerThe dataset turned into a searchable tool.
Step 11Read the patternsWhat the winning posts have in common.
Step 12Concrete ideasVideo ideas, with the evidence attached.
Why I built a strategy when I was only asked for ideas

A list of content ideas with nothing underneath it is just a set of guesses wearing confidence. Anyone can produce ten plausible TikTok ideas for a garden brand in an afternoon, and the problem is that you have no way of knowing which of the ten are any good until months of production have already been spent on them. I would say the ideas are the cheap part. The expensive part is the judgement about which ideas to back, and that judgement is only as good as the research sitting under it.

So I went wider than the brief actually asked for, on purpose. I wanted to understand the brand and the platform well enough that the ideas at the end would be defensible, and that a different person could re-run the method and arrive at a comparable set of ideas. That is the test I held the whole thing to.

02

Reading the brand, finding the USP

The first concrete thing I did was look at the Environmental Factor website and work out, roughly, what they actually sell. The retail side of the shop is built around three collections — pest control, soil amendments and lawn care — and the commercial side mirrors the same three for professional growers and large-scale operations. So there are three product lines, sold into two sectors. I am not a gardening expert, but the structure of the shop made the brand's own framing clear enough: this is a company that is really about taking care of your soil naturally, by keeping pests out and keeping the lawn and soil healthy.

That told me what they sell. It did not yet tell me what makes them different, and at the awareness and consideration stage, difference is the thing you are actually marketing. You cannot differentiate a brand in content if you do not know what its difference is. So I went to the About Us page, where it becomes clear that the pesticides are biological and free of neonics. Environmental Factor Inc. describes itself as an Ajax, Ontario biotech company developing organic, neonic-free bio-pesticide products.

Log · page 2Retail & commercial shop
Three product lines · two sectors
Page 2 →
Pest control, soil amendments, lawn care — the brand's own structure
Log · page 2The About Us page
Biological · neonic-free · Ajax, Ontario biotech
Page 2 →
Where the actual differentiator surfaces — and where my next question came from

The neonics detour

The word "neonics" was doing a lot of work on that About Us page, and I did not actually know exactly what neonics were. Rather than wave past it, I ran a quick Google search, because if neonic-free is the brand's differentiator then I needed to understand it well enough to build content around it. The AI Overview for neonicotinoids was blunt: they are systemic, water-soluble pesticides that persist in soil and water, killing beneficial insects, pollinators and birds while contaminating ecosystems. A single coated seed can contain enough pesticide to kill over 250,000 bees. They are persistent, mobile, toxic to aquatic invertebrates, and linked to declines in bird and fish populations.

That detour is what gave me the actual USP in a form I could write content around. Stripped of the chemistry, the main selling point of using Environmental Factor products is that you are not killing beneficial insects and destroying the surrounding ecosystem just to produce your garden or protect your soil. That is a sentence a non-expert can understand, and it is a sentence content can be built on.

Log · page 3Google · "what are neonics"
The research detour that turned a label claim into a usable USP
Open page 3 →
The neonicotinoids AI Overview — read so the differentiator could be explained, not just repeated
Why I would not skip the neonics search

It would have been faster to take "neonic-free" at face value and move on. The problem is that you cannot build awareness content around a word you cannot explain. Awareness content, by definition, is aimed at people who do not know the category yet, which means the brand has to be able to teach the difference clearly and a little patiently. If I do not understand the difference myself, the content ends up either vague or quietly wrong, and on a topic adjacent to ecosystem harm, quietly wrong is not a risk worth taking.

I would say this is the small habit that separates research from skimming. The five minutes spent understanding what neonics actually are is what later let me frame the whole content angle around ecosystem protection rather than around a chemistry term nobody outside the trade recognises.

03

The funnel call

Environmental Factor sells into both retail and commercial sectors, so B2B content was always going to be possible at some point. But for an initial TikTok content strategy, I considered B2C the better priority, and I decided to focus there first. The reasoning is partly about the platform — TikTok's organic reach skews to consumers browsing for themselves — and partly about being able to test a new strategy cleanly before widening it.

With the sector decided, I sketched the audience pathway I was actually designing content for. A user is browsing TikTok and searches for, or simply engages with, gardening and growing content. Some of that content comes from major brands, and a lot of it comes from dedicated gardening creators — accounts like Creative Explained and Epic Gardening, both of which have built very large followings on exactly this kind of organic, helpful gardening content.

Log · page 4The creators the audience already follows
Creative Explained · 7.3M followers — Epic Gardening · 3.3M followers
Open page 4 →
The benchmark for tone — educational, hands-in-the-soil content, not product advertising

This type of user is almost certainly more likely to respond to, engage with and follow a brand than they are to respond to pure sales advertising — especially if they are not yet sure which product, or even which kind of product, they need. And as they find the content useful, they become more inclined later on to be receptive to a conversion post, or to look the brand up themselves to see whether it has the product they have realised they want. That is the whole pathway: useful content earns the follow, the follow earns the later permission to sell.

This was not a hypothetical for Environmental Factor. Earlier in the same co-op placement at Phoenix Agency I had already produced Instagram posts for the brand, and looking back at them confirmed the pattern. The "4 Benefits Of Having Plants In Your House" post — which I produced myself — is awareness content about the benefits of having plants at all, rather than an attempt to cold-sell a gardening product. Most of the brand's YouTube content followed the same logic: videos about pest, lawn and soil control problems, such as how to get rid of raccoons, rather than sales adverts.

Log · page 6The brand's existing awareness content
An Instagram post I produced for EF · the brand's "how to get rid of raccoons" YouTube video
Open page 6 →
Existing content already leans awareness-first — the TikTok strategy extends a pattern rather than inventing one
Why B2C first, and why awareness first

There is a temptation, when a brand sells into a commercial sector with bigger order values, to chase the B2B content first. I would say that is the wrong sequencing for a first TikTok test. B2B buyers in pest control and soil are not really discovering suppliers through TikTok's organic feed, and trying to serve them there means fighting the platform's grain. B2C is where TikTok's reach actually is, and it gives you a clean, lower-stakes surface on which to prove the method works before anyone widens it.

Awareness first is the same logic one ring in. The competitive, expensive part of any market is the people ready to buy now. The cheap, winnable part is everyone earlier than that. So the content has to meet people while they are still curious, not while they are comparing checkout pages.

04

What the product does

At the awareness and consideration stage you are not really marketing specific products yet — at the awareness stage especially, the job is building reach and getting people to engage with and follow the page. Even so, I took a close look at the product list, because it tells you which topics are even possible to make content around, and which ones will connect back to something the brand can actually sell once a viewer is ready.

The retail pest-control range covers a long list of jobs: grub control; fungus, gnat and thrips control; globe, flea and chinch control; weevil and borer control; slug control; ant control and ant repellent; beneficial nematodes; and pot poppers, which protect against aphids or fungus gnats. On the soil-amendment side there is Turf Maize and its fertilizer for healthier turf, water retention crystals that reduce how often you have to water, Genus MC8 for healthier soil, diatomaceous earth that dehydrates pest insects, and Cropsil for plant nutrients.

Log · page 5The product list, written as jobs
Pest control and soil amendments — catalogued by what each product does
Open page 5 →
The same range, recorded as outcomes rather than product names — the framing that fed the topic clusters

The deliberate move here was to record the range by what each product does rather than by what it is. Water retention crystals became "reduce how often you water." Genus MC8 became "get healthier soil." Diatomaceous earth became "control insects naturally instead of spraying chemicals." The one exception I made was pot poppers, which I kept under their product name, because they are a specific, slightly unusual product that people might genuinely be curious about by name.

This is a large list, and the brand could technically make content about every item on it. But especially when you are testing a brand-new strategy, it is far more useful to find out what content people are already searching for — and what is not too competitive — than to assume the whole catalogue deserves equal airtime. That is what the next eight steps are for.

Why "what it does" beats "what it is"

A product name is a dead end for awareness content. Nobody who has not heard of Environmental Factor is searching for "Genus MC8." They are searching for healthier soil, or for why their lawn keeps dying, or for how to stop slugs without poison. If the product list stays written in product names, it stays disconnected from the language real demand uses, and you end up making content for a search nobody runs.

Rewriting the range as jobs is a small step, but it is what actually connects the product catalogue to the keyword work that runs later. Every "does" phrase is a candidate topic. Every "is" phrase is not. I would say doing this translation early is what kept the later spider-web work pointed at things the brand can credibly stand behind.

05

The data problem, and three clusters

Here is the structural problem with planning TikTok content properly. TikTok does have a trends tool and a Creative Center, but there is no real equivalent of the software you would use in SEO to see specific topic demand — no clean "search volume" figure for a topic the way Google-side tools give you. So a serious content plan for TikTok cannot just read demand off a dashboard. It has to construct the demand signal from several places that were never designed to be combined.

Before doing any of that, I needed somewhere for the signal to land. I settled on three initial content clusters, chosen specifically for non-brand-aware queries — the searches made by people who do not know Environmental Factor exists yet. The three clusters map directly onto what the company sells: pest control, soil amendments and lawn care.

Cluster 01 · Awareness + Consideration

Pest control

The brand's most direct line — protecting a garden from pests without neonics. Wide demand, but heavily contested by pest-control companies, so it needs aggressive filtering for awareness relevance.

Cluster 02 · Awareness

Soil amendments

Healthier soil, healthier turf, less watering. Sits naturally in the educational, do-it-yourself gardening lane where TikTok's organic reach actually lives.

Cluster 03 · Awareness

Lawn care

Keeping a lawn healthy. A real audience, but the search language leans toward hiring a lawn-care company — so, like pest control, it needs the consumer-intent terms separated out.

To keep the dataset legible as it grew, I built a single Google Sheet and divided it into those three clusters from the start, so that every term added later — from whatever source — would inherit a known category. I also pre-added the future columns I knew I would need for the per-platform Answerthepublic traffic data, rather than bolting them on later. The sheet began as four rows: a header, then one seed row per cluster, each marked with its source as "cluster itself."

Log · page 7The master sheet on day one
Three clusters seeded · traffic columns pre-added before any data exists
Open page 7 →
The empty schema — prompt name, cluster category, source, and per-platform traffic columns waiting to be filled
Why the spreadsheet shape mattered before any data went in

I have inherited datasets where someone added columns halfway through a project, and the older rows just end up orphaned and inconsistent. So I spent the first part of this work deciding the schema rather than collecting data, specifically so it would not have to change later. Dividing by cluster up front means every later term carries a parent category for free. Pre-adding the per-platform traffic columns means the data has somewhere to land the moment a tool surfaces it, instead of triggering a restructure mid-flow.

It is not glamorous work, and it is tempting to skip it and start "doing research." But I would say a clean schema set before the first data point is what lets a dataset grow to hundreds of rows and still stay sortable, filterable, and re-cuttable by source. The shape is the part you cannot fix cheaply later.

06

Anchoring with Google Trends

Google Trends is not a TikTok tool, and that is exactly why it goes first. It is free and fast, and before committing time to recursive keyword expansion, it answers one cheap question per cluster: is there meaningful interest behind this topic at all? A topic that is flat at zero on Trends is unlikely to be worth building a TikTok content pillar around, whatever else the other tools say. The pattern per cluster was simple — drop the seed term in, read Interest Over Time, then read the Top queries and Rising queries tables for sub-terms worth promoting into the master sheet.

The first cluster I ran was pest control. Interest in the term itself was reasonable — not sky-high, but with clearly visible, sustained demand. The related-queries tables were busier, but most of the strong terms pointed at pest-control companies — "pest control near me," "best pest control," "pest control services." So I focused only on the terms that could actually work for Environmental Factor at the awareness and consideration stage, and added those relevant ones to the list.

Log · page 7Trends · "pest control"
Reasonable, sustained interest
Page 7 →
Demand is real — but the related queries skew to companies, not consumers
Log · page 8Top & Rising queries
Filtering company-intent out of the cluster
Page 8 →
Only the awareness-relevant terms get promoted — "home pest control," "termite pest control"

Soil amendments came next, and again showed reasonable interest, which is a good sign for a cluster. Here there were a lot more usable options, and I added them to the list, focusing mostly on terms that could relate either to soil-amendment advice or to products that Environmental Factor actually sells — "organic amendments," "compost," "garden soil amendments," and similar. Lawn care followed the same routine. Many of the lawn-care topics related to contracting a lawn-care company rather than doing it yourself, so I took only the relevant ones, the same way I had with pest control.

At the end of the Trends pass the overall list was not very long yet. That is fine. Trends is the gate, not the verdict. Its job is to confirm each cluster has a pulse and to hand over a small set of credible seed terms — the recursive expansion happens later, with a different tool.

Log · page 9Trends · "soil amendments"
Reasonable interest · many usable sub-terms
Page 9 →
The richest of the three clusters for promotable terms
Log · page 10Trends · "lawn care"
Real demand, heavy company-intent
Page 10 →
Only the do-it-yourself terms survive — "green lawn care," "how to reseed a lawn"
The filter I was applying without quite naming it

Across all three clusters the same judgement kept recurring: a term has traffic, but the traffic is people looking to hire a company, not people looking to do the thing themselves. "Pest control near me" is a strong term and a useless one for this brand, because Environmental Factor sells products, not a local service. Promoting it into the sheet would have inflated the dataset with demand the brand cannot convert.

So the rule I was applying, even before I wrote it down, was intent-shaped: keep terms a consumer would search while trying to solve a garden problem themselves, drop terms a consumer would search while trying to outsource it. That single distinction is what kept the cluster lists honest, and it is the same logic I later handed to Claude in a more formal form.

07

The Creative Center pass

With the Trends pass done, I went to TikTok's own tool — the Creative Center. It is worth being clear about what it is and is not. The Creative Center is built mostly to show data on specific ads and posts, not topic demand the way an SEO tool would. So I did not expect it to replace the demand research. What I wanted from it was narrower: to see whether any of the main hashtags and category terms relevant to the brand were trending, and to pick up format ideas along the way.

I started with the general industry categories. Environmental Factor's products straddle a few of them — Household Products contains a Pest Control sub-category, and Home Improvement contains Interior Design & Decorating. Browsing the keyword popularity inside those categories surfaced a few genuinely interesting terms: "your home," which was both high in volume and rising sharply, alongside "cockroach killer" and "cockroach exterminator." I added "your home," "cockroach killer" and "cockroach exterminator" to the master list, and I also added "home improvement" itself as a new prompt category, since it clearly framed a chunk of relevant demand.

Log · page 11Creative Center · industry filters
Pest Control · Interior Design & Decorating
Page 11 →
Finding which of TikTok's own categories the brand actually sits inside
Log · page 12Keyword popularity table
"your home" +153% · "cockroach killer" · "cockroach exterminator"
Page 12 →
Three terms promoted into the sheet · "home improvement" added as a new category

I also looked at TikTok's trending hashtags for more ideas. Inside the Home Improvement category I found a few worth keeping — #garden and #plants, each sitting at around 2,000 posts in the window, and #patio at roughly 850. None of those are surprising for a garden brand, but seeing them register as live, trending hashtags on the platform itself is a useful confirmation that the clusters were pointed in the right direction.

Log · page 13Creative Center · trending hashtags
#garden · #plants · #patio — trending inside the Home Improvement category
Open page 13 →
Platform-side confirmation that the garden-content clusters have live trend activity behind them
Using each tool for the one job it is good at

It would be a mistake to ask the Creative Center to be a demand tool. It is not one, and pretending otherwise would mean reading its post-level data as if it were search volume. What it is good at is two narrower things — telling you which of TikTok's own categories your brand belongs in, and surfacing hashtags that are trending right now. So I used it for exactly those two things and nothing more.

I would say this is the discipline that keeps a multi-tool method honest. Google Trends validates clusters. The Creative Center finds categories and trending tags. Answerthepublic builds the recursive demand web. Each tool answers the question it can actually answer, and the dataset stays trustworthy because no single tool is being asked to do a job it was not built for.

08

Building the spider web

This is the step that builds the demand signal TikTok itself will not give you. The idea is straightforward. A seed term goes into Answerthepublic; every related query that comes back with identifiable traffic becomes the next seed; each of those produces its own children, and so on, until the branches stop returning traffic. The result is a dataset much wider than any single tool would hand you, weighted naturally toward terms that have real demand rather than theoretical demand.

To show the method rather than just describe it, I ran the first term — "pest control" — entirely by hand. Answerthepublic returned a Google search volume of 246K on the seed term, marked High, with a Cost Per Click of $20.64, marked Medium. That figure went straight into the traffic column against what had been an empty seed row minutes earlier, and it was the first real data point in the dataset.

Log · page 14The master sheet before the manual run
22 seed rows from the cluster, Trends and Creative Center passes — "pest control" picked to expand by hand
Open page 14 →
Everything gathered so far in one sheet, source-attributed, ready for the spider-web expansion
Log · page 15Answerthepublic · "pest control" run by hand
246K search volume · $20.64 CPC — the first real number in the sheet
Open page 15 →
The worked example — one term expanded manually so the method is legible before it gets automated
Log · page 16The AI Prompts & Keywords panels
Ideas with no traffic data — parked, not promoted
Open page 16 →
Good-looking prompt ideas, but no measured demand behind them yet — held back deliberately

The AI Prompts panel was the first thing I deliberately did not use. It surfaces a long list of natural-language questions people ask AI tools, and the ideas can be good ones — but they are not yet based on actual measured searches, and they carry no traffic data. So I parked them. If that data matures and starts carrying real volume, I would absolutely use it; for now it stays out. The Keywords panel below it did carry volume, so from there I had to weigh which queries genuinely relate to something Environmental Factor sells or provides and still have demand behind them.

The People Also Ask mind map was the most useful single screen in the flow — a visual spider web of question-shaped queries branching off the seed. Here I chose to take all the main terms, because they offered a good mix of awareness and consideration content. "Pest control treatment" is a borderline case: it could refer to a company's service, but it can equally refer to a product, so I judged it worth including. The YouTube and TikTok panels added their own signal — "what is pest control" carried 1.6K of YouTube traffic, and several TikTok-specific terms like "how pest control works" carried real volume too. The longer, informative format that wins on YouTube tends to translate well to TikTok's own longer-video format, so those went into the sheet. The Instagram data I noted as a demand signal even though this is a TikTok strategy, because a topic that draws people on one platform is at least evidence the topic has pull.

Log · page 17People Also Ask mind map
Question-shaped demand around the seed
Page 17 →
A good mix of awareness and consideration questions — most promoted
Log · page 20Per-platform traffic captured
YouTube · TikTok · Instagram volumes added per row
Page 20 →
Instagram kept as a demand signal even though the strategy is TikTok-only
Log · page 18The YouTube keyword panel
"what is pest control" · 1.6K YouTube traffic
Page 18 →
Longer-format YouTube demand — the kind that translates to TikTok's longer-video format
Log · page 19The TikTok keyword panel
"how pest control works" and others — TikTok-specific volume
Page 19 →
Every TikTok term carrying traffic copied straight into the sheet

Handing the expansion to Claude

Expanding one term manually is fine as a demonstration, but the spider web gets large fast — every term with traffic spawns its own set of children, and doing all of that by hand at scale would have eaten weeks on work that is almost entirely data-shaping rather than judgement. So from this point I set up a Claude project to take the Answerthepublic exports and the manual screenshots of traffic data and write them straight into the spreadsheet. I gave it a fixed set of rules so the automation could not quietly drift.

Rules I gave Claude for the spider-web expansion
Log · page 21The next seed · "soil amendments"
8.1K search volume · $0.66 CPC
Page 21 →
A cheaper, lower-volume term than pest control — a different shape of demand
Log · page 22The Claude integration project
"EF ATP integration project" — the exact prompt
Page 22 →
"Add all of them to the spreadsheet to build a spider web of data, fill in all traffic data, exclude any terms with no traffic"

Once the Claude pattern was working, the dataset grew quickly into a large list of topics — wide enough that, as a searchable database, it could serve many use cases beyond this one project. That breadth is useful, but it also created the next problem. A few hundred candidate topics is too many to commission content against directly. The list needed ranking before it could be acted on.

Why automate the shaping but not the judgement

The work in the spider web splits cleanly into two kinds. One kind is mechanical — copying traffic numbers off an export into the right cell, expanding a term's children, applying a yes/no rule. The other kind is judgement — deciding that "pest control treatment" is ambiguous-but-worth-keeping, or that Instagram volume counts as a signal even on a TikTok project. I would say the first kind is exactly what you hand to Claude. The second kind is the part you keep doing yourself, because that is where the dataset earns whatever trust it ends up carrying.

The rules I wrote were essentially the seam between the two. By fixing the exclusions in writing — traffic required, no competitors, no zero-traffic terms, nothing tied to a non-Canadian location — the automation had no room to improvise. It shaped the data fast, and every actual decision about what the data meant stayed with me.

09

Ranking the dataset

The plan from here was a manual TikTok audit — watching the ten posts that surface for a query and recording how they perform. But auditing every term in a several-hundred-row dataset is not realistic, so I needed to choose which queries to audit. The audit set I settled on was: all the cluster topics, everything identified through the TikTok Creative Center, everything identified through Google Trends, the top five Answerthepublic TikTok posts, and the top five Answerthepublic Google posts.

To get a ranked shortlist out of the raw traffic numbers, I wrote a small PowerShell script to pull a pure top-ten of the queries with the most identified traffic. The first run came back looking productive and being mostly useless: "garden of the gods" at 368K, "compost bin" at 301K, "patio furniture" and "pest control near me" both at 246K, "plants vs zombies" at 201K, "garden snake," "garden raised bed," "lawn care services," "pest control service." Plants vs Zombies is a video game. Garden of the Gods is a scenic landmark. Most of the rest did not really relate to anything Environmental Factor sells.

Log · page 23PowerShell · first top-10 run
High traffic, low relevance
Page 23 →
"Plants vs zombies" is a game · "garden of the gods" is a landmark — traffic alone mis-ranks the list
Log · page 24PowerShell · refined run
Scoped to pest control, lawn care, fertilizer
Page 24 →
"Garden city" excluded, "garden instrument" kept — the script tuned to what the brand actually sells

So I ran it again, this time excluding the obvious noise — "garden city" came out, and "garden instrument" stayed in its place. Then I changed the script properly, focusing it on the three things the company actually sells: pest control, lawn care and fertilizer. With the ranking scoped to the brand rather than to raw traffic, the top-ten became a list of queries worth the time of a manual audit, and from there I could start the audit itself.

Why a ranking is only as honest as its inputs

The first PowerShell run is a good illustration of a trap that is easy to fall into with any automated ranking. The script did exactly what it was told — sort by traffic, take the top ten — and produced a precise-looking but almost worthless list, particularly because traffic volume on its own does not know the difference between a pesticide and a video game called Plants vs Zombies.

The fix was not a cleverer sort. It was tightening what the script was allowed to consider in the first place — scoping it to pest control, lawn care and fertilizer. I would say that is the general lesson here: when a ranking looks wrong, the problem is usually upstream, in the terms you let into the calculation, rather than in the ranking logic itself.

10

The TikTok Audit Explorer

The manual audit produces a lot of rows — every query carries up to ten posts, each with a creator, an engagement figure and notes — and a long spreadsheet is not something a strategy team will actually use. So I turned the audited dataset into a small searchable HTML tool, the TikTok Audit Explorer. It is not meant to be pretty. It is meant to let anyone open it, search a query, sort by engagement, and reach the underlying posts in a couple of clicks — and to keep doing that after I am no longer on the brand.

In its finished version the Explorer covers 129 unique queries and 418 post observations, captured across the 5th and 7th of May 2026, with 314M of total engagement recorded. One column is honestly empty: zero posts carried usable view-count data, because TikTok's search-results cards do not reliably expose views, so the audit recorded engagement and left views blank rather than guessing. Below is a faithful rebuild of the Explorer's top view.

TikTok Audit Explorer — EF
Pest control · lawn care · soil amendments · home/garden — captured May 5 & May 7, 2026
All queries (129)
129
Unique queries
418
Post observations
314M
Total engagement
0
Posts with view data
Top 10 queries by post count
compost30 posts
organic amendments24 posts
garden soil amendments21 posts
organic soil amendments20 posts
home pest control14 posts
#garden13 posts
(related to) organic soil amendments12 posts
patio11 posts
(related to) compost11 posts
termite pest control11 posts
compost#1 · 30×
30 posts · 228K total engagement
Top post: Little Pepino — #composttips 4 things I wish I knew before sta… (66K eng.)
organic amendments#2 · 24×
24 posts · 26K total engagement
Top post: torriangardens — Amendments organic — Starting a garden as a… (9.1K eng.)
garden soil amendments#3 · 21×
21 posts · 15K total engagement
Top post: Ray — HOW I CHANGED MY GARDEN SOIL FROM THIS… (8.0K eng.)
organic soil amendments#4 · 20×
20 posts · 4.3K total engagement
Top post: zachslawncar… — They act as a natural soil amendment… (2.5K eng.)
Rebuilt in HTML from the Explorer · the original screenshot is embedded directly below
Log · page 25The Explorer, finished — original screenshot
129 queries · 418 observations · 314M engagement · top 10 by post count
Open page 25 →
The finished tool in the working log — the dataset made searchable, sortable and openable by anyone on the team

The thing the finished Explorer made obvious is a pattern that runs through the rest of this case study. Most of the demand in the popular queries has to do with topics around what the company's products are used for — composting, soil, gardens, lawns — rather than directly about product features or company information. For a brand trying to sell, that could read as a disappointment. For a brand trying to build awareness and consideration content, it is close to ideal: it is exactly the territory that pulls people into the funnel in an organic way, which is what TikTok rewards.

Why the audit had to become a tool, not a tab

A 418-row spreadsheet is technically the same information as the Explorer. But a spreadsheet that size does not really get used — it gets opened once, found intimidating, and closed. The strategy only has value if the people commissioning content can actually interrogate it, and that means the dataset has to be searchable and sortable by someone who was not in the room when it was built.

So I would say the Explorer is not decoration on top of the audit. It is the part that lets the audit actually outlive me on the brand, particularly because the next person can open it cold and find their way around without needing me to explain it. The same instinct ran through every deliverable here.

11

Reading the patterns

With the Explorer built, the actual analysis is query by query — watching the top posts that surface for each one and asking what the winners have in common. I worked down the most popular queries in turn. What follows is the read on each, because the patterns are the part that turns a dataset into a content brief.

Compost & organic amendments — the do-it-yourself rule

For the compost query, almost all the content that earned high engagement was do-it-yourself composting tips. That tells you something specific about a gardening brand on TikTok: just featuring the product is not enough. People want to be inspired about how the product can actually be used in real tasks. Composting content, framed that way, could be a strong way to build an organic funnel.

Organic amendments showed the same theme. People like do-it-yourself content that is informational and educational first, and only then shows specific products. The brand could make a video about building a flower bed, and show its product being used to finish the job — which is essentially how grocery stores feature their own products inside the recipes they post online. The product appears because it belongs in the task, not because the video stopped to advertise it.

Log · page 27Query · "compost"
DIY composting tips dominate the winners
Page 27 →
High-engagement compost content is method content, not product content
Log · page 28Query · "organic amendments"
Educational first, product second
Page 28 →
The grocery-store-recipe model — the product shows up inside the task

Garden soil & organic soil amendments — the USP opening

The garden soil amendments query is where I saw a clear opening to highlight a USP. One of the most popular videos in it was a straightforward "how I changed my garden soil" piece. Environmental Factor could take that exact format and — after a strong hook to engage the viewer — show how its product specifically changes or improves a part of someone's garden soil. The format is proven; the brand just supplies the differentiator.

Organic soil amendments showed a similar opening, with one extra read. People searching this query are likely already asking what the organic alternative is to soil amendments they have used before, which means they arrive half-convinced. But as a criticism of the existing content, almost none of those videos lead with a strong hook. Personally I would open with something like "this changed that about my garden" to draw people in before explaining anything — the demand is there, the hooks are not.

Log · page 30Query · "garden soil amendments"
"How I changed my garden soil" — a USP-ready format
Page 30 →
A proven before-and-after format the brand can pour its differentiator into
Log · page 31Query · "organic soil amendments"
Warm audience, weak hooks
Page 31 →
The demand is half-converted already — the gap is a strong opening hook

Home pest control, #garden & the hook formats

Home pest control was more interesting as a format study than as a topic. Most of the posts were not directly about anything Environmental Factor sells, but the query's popularity flags a real demand for pest-control information, and a recurring format worth stealing: a strong shock hook to pull people in, with some posts literally opening on "don't do this pest control unless you're insane." That shock-hook structure could work well for gardening or, especially, commercial soil pest control.

The #garden query has very high engagement simply because the term is so broad, so my interest there was format rather than topic. The content that wins under #garden is different in kind — short garden skits and timelapse videos largely replace the more informational pieces. Because the niche is so wide, the format I would use is similar skits and timelapses, but ones that ultimately involve the company's products and show the USPs at the end. The related-to-organic-soil-amendments query reinforced the hook lesson again: the posts that performed used a shock hook that names a clear problem and draws people straight into it — the same move you see in effective advertising in fields like healthcare and dieting.

Log · page 32Query · "home pest control"
The shock-hook format · 167K total engagement
Page 32 →
"Don't do this pest control unless you're insane" — the hook doing the heavy lifting
Log · page 33Query · "#garden"
Skits & timelapses · 1.6M total engagement
Page 33 →
A broad hashtag where format, not topic, decides what wins

Patio, compost facts & termite — product placement and surprise

Patio is less relevant to direct gardening or pest control, and the results reflect that. Even so, there is an opportunity to show off beautiful gardens or patios that people made or maintain using the company's products — a kind of product placement, drawing people in with content that has an entertainment angle. The related-to-compost query pointed at a different mechanic: people like longer videos that explain a surprising fact about their do-it-yourself hobby, and the end of a video like that is a natural place for the brand to feature its products or show how to use them for that method.

Termite pest control made the same point again. The winning posts used shock hooks and surprising-fact framing — one of them opening on "you saved the buyer from a future headache" — and the format leaves a clear slot for the brand to feature its products at the end. The tenth query was, again, mostly a format lesson: the company could use it to show how to avoid common gardening problems, opening with a shock hook like "you saved this year's crops by…" and then explaining how the product helps.

Log · page 36Query · "patio"
3.6M engagement · a product-placement opening
Page 36 →
Low topical fit, but a chance to place the product inside aspirational content
Log · page 39Query · "termite pest control"
67K engagement · shock hooks & surprising facts
Page 39 →
A surprising-fact structure with a clean slot for the product at the end
Log · page 34Query · "(related to) organic soil amendments"
The hook lesson again — name a clear problem fast
Page 34 →
Posts that lead with a sharp problem hook sit at the top of the query
Log · page 38Query · "(related to) compost"
Surprising-fact videos about a DIY hobby
Page 38 →
Longer explainer videos — and a natural end-of-video slot for the product
Pattern

Method content beats product content

Across compost and organic amendments, the winners were do-it-yourself tips. People want to be shown how a product is used in a real task — not shown the product on its own.

Pattern

The hook is carrying the video

Home pest control, termite and the related-soil queries all rewarded a strong shock hook that names a clear problem fast — the same move as effective healthcare and dieting ads.

Pattern

The product enters at the end, in context

The repeatable structure is educate first, then let the product appear naturally inside the task, with the USP shown as the close rather than the opening pitch.

Pattern

Demand sits around the product, not on it

Popular queries are about what the products are used for — gardens, soil, lawns — not product features. For awareness content, that is the ideal place to be.

12

The ideas, and what this doesn't prove

The exercise here was never to build a content calendar, let alone produce the content. It was to find the topics and formats worth backing, and to do it with evidence rather than instinct. But the brief did ask for ideas, so the method has to land on some — and based on everything above, these are the ten concrete video ideas I would put forward as actual examples.

01
How to do organic compostingAwareness · method content
02
Creating a raised bed without using chemicalsAwareness · method content
03
HOW I GREW MY GARDEN YEAR ROUND IN CANADA WITHOUT USING CHEMICALSAwareness · shock-hook USP
04
A natural alternative to using chemical pesticidesConsideration · USP
05
Never have spider mites in your garden againConsideration · adapted from home pest control
06
Create a raised flower bed with me — 3-hour timelapseAwareness · timelapse format
07
Your chemical fertiliser is ruining your new gardenAwareness · shock hook
08
POV: You finished your new patioAwareness · entertainment / product placement
09
Did you know not all worms are bad for your garden — 3 ways to tell the good guys apartAwareness · surprising-fact format
10
POV: You kept the slugs out without using chemicalsConsideration · USP
Log · page 40The ten content ideas, in the log
Concrete video examples drawn directly from the audited patterns
Open page 40 →
Each idea traces back to a pattern in the audit — method content, shock hooks, surprising facts, USP closes

What this doesn't prove

There are a few things I want to be straight about. The first I have already said, and it bears repeating: this is a present-day reconstruction, not a record of the original 2023 co-op work. The notes from that placement are gone, so what is documented here is deliberately the method as I would run it today, supported entirely by a fresh 2026 re-run rather than by any 2023 artefacts. The second is scope — this is topic and format discovery, not a content calendar and not an executed campaign, so it tells you what to make and roughly how, but it does not tell you how the resulting content actually performed. That would be the next piece of work, not this one.

The third is that it is deliberately B2C-first. B2B content is possible for Environmental Factor and may well be worth doing, but it was set aside on purpose so the first test could run cleanly on the audience TikTok actually serves. And the audit is a snapshot — TikTok's surface changes fast, so the manual audit should be treated as something to re-run on a regular cadence rather than a permanent answer. None of that undermines the method. The method is the part that survives, because the value here is a process the next person on the brand can re-run and trust, not any single number inside it.

If I were starting this again tomorrow

I would scope the PowerShell ranking to the three product lines from the very first run, rather than discovering the Plants-vs-Zombies problem after the fact — that is a ten-minute fix that would have saved a cleanup pass. I would also build the Audit Explorer one cluster at a time and read each cluster's patterns before auditing the next, instead of auditing everything and then analysing it in a block. Smaller batches, faster correction loops.

But the spine would not change. Read the brand properly, decide the funnel, validate the clusters, build the demand signal the platform refuses to give you, rank it honestly, audit by hand, and let the patterns — not a hunch — choose the ideas.

The full working log

For anyone who wants the raw version rather than the page-by-page excerpts above, the complete 40-page working log is embedded below — every screenshot, every Google Trends read, every spreadsheet state and every audit query in its original order.

Environmental Factor · TikTok topic research — full working log
40 pages · method log + supporting screenshots · re-run Apr–May 2026
Open full PDF →
Source document — every screenshot referenced above, in original order, with surrounding context preserved
Picking the topic is the cheapest decision in a content programme and the one most often skipped. Every decision after it — the format, the creator, the budget — is quietly assuming the topic was right. So I would say it is worth auditing the topic like the budget line it really is.

What this built — from a brief that only asked for ideas

What now exists

  • A three-cluster topic universe for Environmental Factor — pest control, soil amendments and lawn care — validated against Google Trends, the TikTok Creative Center and Answerthepublic.
  • A several-hundred-row spider-web dataset of search demand, built with a documented, rule-bound Claude workflow that the next operator can re-run.
  • 418 TikTok post observations audited by hand across 129 queries, turned into the searchable TikTok Audit Explorer.
  • A clear read on the formats that win — method content, shock hooks, surprising facts, USP-at-the-close — and ten concrete video ideas drawn from them.
  • An honest scope statement, with the reconstruction, the B2C-first choice and the snapshot limitation written in rather than hidden.

What it enables

  • Awareness and consideration content that draws people into the funnel organically, without the recurring cost of paid reach.
  • A repeatable, $0-tooling method — Google Trends, Creative Center, Answerthepublic, Claude, PowerShell — re-runnable on any quarter or any rebrand.
  • A content direction defensible to a manager, because every idea traces back to an audited pattern rather than to a hunch.
  • A clean starting point for the work this does not cover — a B2B pass, and an actual content calendar and performance test.

Phoenix Agency co-op · TikTok content strategy for Environmental Factor

Rupert Thieme · rebuilt Apr–May 2026 as the method I would run today